LOAD DATA
characterset UTF8
APPEND INTO TABLE t_resident_switch
FIELDS TERMINATED BY ','
trailing nullcols
(
rangetime date "yyyy-mm-dd hh24:mi:ss",
line,
city,
srccellid,
srccellname,
targetcellid,
targetcellname,
success,
switchcause,
rsrp,
destrsrp,
ueboot,
upsigrate,
rip,
destrip,
lat,
lon,
imsi
)